Overview

When viewing your Work in Progress (WIP) analysis report (SA3487), you may notice a large difference between your Net WIP balance (the total amount for your WIP transactions) and your account balance.

This can be caused by having a non-WIP account set as a job’s WIP account.  The result is that not all transactions in the account are WIP transactions and this can lead to a large discrepancy.

How do I fix this?

1. Enter the affected account number into the WIP account code filter and select Don't group, show full details.

2. Re-run the report to locate the Job codes that have this account set as a WIP account.
3. Navigate to the Job codes identified above and select the Setup tab.
4. Select Edit and update the Work in progress account details to the correct WIP account.

5. Navigate to each transaction that was processed while the previous account was set and select Edit then Update to reprocess them.

Did you find this article helpful?

If this article is missing information, ambiguous or didn’t give you clear instructions, let us know and we will make it better! Please email us and quote the KB# in the top left of this article to let us know why it didn’t help you out and we will point you in the direction of additional information.

Last edit: 29/07/2026